home *** CD-ROM | disk | FTP | other *** search
/ Software of the Month Club 1996 May / Software of the Month Club 1996 May.iso / mac / ISO9660 / OS2 / MESA / EXAMPLES / ACCOUNT.M2 next >
Encoding:
Text File  |  1995-10-10  |  85.0 KB  |  433 lines  |  [TEXT/hscd]
  1. Mesa2DPP#G╚
  2. _╙ÇZⁿ   √   êd        ÇÇ
  3. Script  1        ÇÇ
  4. Script  2                                                                                                                            ∞
  5. Helv⌠≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡?≡? Ω       └└└╠╠╠└└└Cover HkkL╖½¬J    #5Åí┼
  6. ╪ √¥?ε â
  7.    └└└╠╠╠└└└    Checking HmmJ╖úΩ0%     └└└╠╠╠└└└Savings Hi▒á& ┤ applepÇCATpÇCheckingBalancepÇDOGpÇSavingsBalance pÇ┐!
  8. Script  1φ/* The purpose of this MScript is to move the     */
  9. /* entry on the Cover Page into either the     */
  10. /* checking or savings account based on the     */
  11. /* Transaction Type Specified by the user.    */
  12.  
  13. /* Create the variables we will use.         */
  14. counter:    /* For finding the right row.      */
  15. searchvalue:    /* For finding the right row.      */
  16. layer:        /* Which layer are we on.    */
  17. transactiontype:
  18. withdrawal:    /* 1 if a withdrawal, 0 if not    */
  19. deposit:        /* 1 if a deposit, 0 if not    */
  20. transfer:    /* 1 if a transfer, 0 if not    */
  21.  
  22. /* Set counter to row 9.             */
  23. counter = 9
  24.  
  25. /* Initialize all of the other variables to 0.     */
  26. searchvalue = 0
  27. layer = 0
  28. transactiontype = 0
  29. withdrawal = 0
  30. deposit = 0
  31. transfer = 0
  32. test = 0
  33.  
  34. /* Get the Transaction Type.            */
  35. transactiontype = getc("[Cover]a21")
  36.  
  37. /* Determine what action to take based on     */
  38. /* the Transaction Type.             */
  39.  
  40. /* Remember to put the ' character before    */
  41. /* all of the text we will import as Mesa 2     */
  42. /* inserts horizontal alignment characters    */
  43. /* ALA 123.                    */
  44. IF transactiontype = "'ATM" THEN DO
  45.    layer = 2
  46.    withdrawal = 1
  47. END 
  48. ELSE IF transactiontype = "'CDeposit" THEN DO
  49.    layer = 2
  50.    deposit = 1
  51. END 
  52. ELSE IF transactiontype = "'SDeposit" THEN DO
  53.    layer = 3
  54.    deposit = 1
  55. END 
  56. ELSE IF transactiontype = "'Interest" THEN DO
  57.    layer = 3
  58.    deposit = 1
  59. END 
  60. ELSE IF transactiontype = "'Transfer" THEN DO
  61.    layer = 2
  62.    transfer = 1
  63. END 
  64. /* Everything else failed, assume it is a     */
  65. /* check with a number in the Transaction     */
  66. /* Type field.     */
  67. ELSE DO 
  68.    layer = 2
  69.    withdrawal = 1
  70. END
  71.  
  72. /* Select the Layer, this is not needed, it just    */
  73. /* makes things look better.            */
  74. Sel(cell(1,1,layer))
  75.  
  76. /* Find the last line of the data.         */
  77. DO FOREVER,
  78.    UNTIL searchvalue = ""
  79.    searchvalue = getc(cell(counter,1,layer))
  80.    counter = counter + 1
  81. END
  82.  
  83. /* Move the Total line down by one row.     */
  84. Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  85. copy()
  86. Sel(cell(counter+1,1,layer))
  87. paste()
  88. Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  89. clear()
  90.  
  91. /* Set the labeled range to the new line so we    */
  92. /* can get the latest balance automatically.        */
  93. IF layer = 2 THEN DO
  94.    SetLabel("CheckingBalance",cell(counter+1,7,layer))
  95. END
  96. ELSE DO
  97.    SetLabel("SavingsBalance",cell(counter+1,7,layer))
  98. END
  99.  
  100. /* Select Cover Layer this is not needed, it     */
  101. /* just makes things look better.        */
  102. Sel("[Cover]A1")
  103.  
  104. /* Copy the first 3 cells to the correct entry.     */
  105. Sel("[Cover]a21:[Cover]c21")
  106. copy()
  107. Sel(cell(counter-1,1,layer))
  108. paste("Values")
  109.  
  110. /* Make sure the second cell is Date Formatted.    */
  111. Sel(cell(counter-1,2,layer))
  112. SetFormat("MM/DD/YY")
  113.  
  114. /* Get the value of the transaction.         */
  115. value = getc("[Cover]d21")
  116.  
  117. /* Select the Layer, this is not needed, it just    */
  118. /* makes things look better.            */
  119. Sel(cell(1,1,layer))
  120.  
  121. /* Copy the value into the correct entry.     */
  122. IF withdrawal = 1 THEN DO
  123.    putc(value,cell(counter-1,5,layer))
  124.  
  125. /* Format the right cells.             */
  126.    Sel(cell(counter-1,5,layer))
  127.    SetFormat("currency1","2")
  128.    Sel("[Checking]f10:[Checking]g10")
  129.    copy()
  130.    Sel(cell(counter-1,6,layer))
  131.    paste()
  132.  
  133. /* Set deposit back to 0.             */
  134.    withdrawal = 0
  135. END
  136. ELSE IF deposit = 1 THEN DO
  137.    putc(value,cell(counter-1,4,layer))
  138.  
  139. /* Format the right cells.             */
  140.    Sel(cell(counter-1,4,layer))
  141.    SetFormat("currency1","2")
  142.    Sel("[Checking]f10:[Checking]g10")
  143.    copy()
  144.    Sel(cell(counter-1,6,layer))
  145.    paste()
  146.  
  147. /* Set deposit back to 0.             */
  148.    deposit = 0
  149. END
  150. /* If it isn't a withdrawal or a deposit then it    */
  151. /* is a transfer.                    */
  152. ELSE DO
  153.    putc(value,cell(counter-1,5,layer))
  154.  
  155. /* Format the right cells.             */
  156.    Sel(cell(counter-1,5,layer))
  157.    SetFormat("currency1","2")
  158.    Sel("[Checking]f10:[Checking]g10")
  159.    copy()
  160.    Sel(cell(counter-1,6,layer))
  161.    paste()
  162.  
  163. /* Set the following values so we can change    */
  164. /* the savings layer.                */
  165.    layer = 3
  166.    counter = 9
  167.    searchvalue = 0
  168.  
  169. /* Find the last line of the data of the savings */
  170. /* layer                     */
  171.       DO FOREVER,
  172.        UNTIL searchvalue = ""
  173.        searchvalue = getc(cell(counter,1,layer))
  174.        counter = counter + 1
  175.       END
  176.  
  177. /* Move the Savings Total line down by one     */
  178. /* row.                     */
  179.    Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  180.    copy()
  181.    Sel(cell(counter+1,1,layer))
  182.    paste()
  183.    Sel(cell(counter,1,layer)":"cell(counter,7,layer))
  184.    clear()
  185.  
  186. /* Set the labeled range to the new line so we */
  187. /* can get the latest balance automatically.    */
  188.    SetLabel("SavingsBalance",cell(counter+1,7,layer))
  189.  
  190. /* Copy the first 3 cells to the correct entry.     */
  191.    Sel("[Cover]a21:[Cover]c21")
  192.    copy()
  193.    Sel(cell(counter-1,1,layer))
  194.    paste("Values")
  195.  
  196. /* Make sure the second cell is Date Formatted.    */
  197.    Sel(cell(counter-1,2,layer))
  198.    SetFormat("MM/DD/YY")
  199.  
  200. /* Copy the value into the correct entry.     */
  201.    putc(value,cell(counter-1,4,layer))
  202.  
  203. /* Format the right cells.             */
  204.    Sel(cell(counter-1,4,layer))
  205.    SetFormat("currency1","2")
  206.    Sel("[Checking]f10:[Checking]g10")
  207.    copy()
  208.    Sel(cell(counter-1,6,layer))
  209.    paste()
  210.  
  211. /* Set transfer back to 0.             */
  212.    transfer = 0
  213. END
  214.  
  215. /* We are done updating everything.  Now go    */
  216. /* reset the row 21 of the Cover Page so we     */
  217. /* can do this again.                */
  218. Sel("[Cover]a21:[Cover]d21")
  219. clear("Values")
  220.  
  221. /* And go set all of the variables back to     */
  222. /* what we started with.            */
  223. counter = 0
  224. searchvalue = 0
  225. layer = 0
  226. transactiontype = 0
  227. withdrawal = 0
  228. desposit = 0
  229. transfer = 0
  230.  
  231. `"
  232. Script  2â/* Reset script so I can reset the labeled ranges     */
  233. SetLabel("CheckingBalance","[b]g20")
  234. SetLabel("SavingsBalance","[c]g13")
  235. -#dHHHH Helv Helv Helv Helv Helv Helv Helv Helvq#   d   └└└└└└@╡#   d   └└└└└└@∙#   d   └└└└└└@=$   d   └└└└└└@ü$   d   └└└└└└@┼$   d   └└└└└└@    %   d   └└└└└└@M%   d   └└└└└└
  236. @æ%   d   └└└└└└
  237. @╒%   d   └└└└└└@&   d   └└└└└└
  238. @]&   d   └└└└└└    @í&   d   └└└└└└    @σ&   d   └└└└└└    @)'   d   └└└└└└@m'    d   └└└└└└@▒' d   └└└└└└⌡'   d   └└└└└└9(╨╨╨d   └└└└└└}(ÇÇd   └└└└└└┴( Çd   └└└└└└)   d   └└└└└└I)Çd   └└└└└└ì)Ç   d   └└└└└└╤)    d   └└└└└└@*Ç   d   └└└└└└@Y*   d   └└└└└└@¥*   d   └└└└└└@ß* d   └└└└└└%+ d   └└└└└└
  239. i+ d   └└└└└└¡+ d   └└└└└└±+ÇÇÇd   └└└└└└5,ÇÇÇd   └└└└└└
  240. y,ÇÇÇd   └└└└└└╜,ÇÇÇd   └└└└└└- d   └└└└└└E-  d   └└└└└└ë-  d   └└└└└└
  241. ═-  d   └└└└└└.  d   └└└└└└U. d   └└└└└└Ö.Ç d   └└└└└└▌. d   └└└└└└!/ÇÇÇÇd   └└└└└└e/    d   └└└└└└@⌐/  d   └└└└└└φ/  d   └└└└└└
  242. 10  d   └└└└└└u0  d   └└└└└└╣0  d   └└└└└└²0  d   └└└└└└A1 d   └└└└└└à1    d   └└└└└└@╔1    d   └└└└└└@2   d   └└└└└└
  243. Q2   d   └└└└└└
  244. @ò2   d   └└└└└└    ┘2   d   └└└└└└    @3   d   └└└└└└@a3   d   └└└└└└@Ñ3    d   └└└└└└    @Θ3    d   └└└└└└    D-4   d   └└└└└└@q4ÇÇÇd   └└└└└└╡4ÇÇÇd   └└└└└└    ∙4 ÇÇÇd   └└└└└└=5 ÇÇÇd   └└└└└└    ü5 ÇÇÇd   └└└└└└┼5   ÇÇÇd   └└└└└└    6   ÇÇÇd   └└└└└└    M6   ÇÇÇd   └└└└└└æ6└└└d   └└└└└└╒6└└└d   └└└└└└    7└└└d   └└└└└└]7└└└d   └└└└└└í7└└└d   └└└└└└σ7└└└d   └└└└└└    )8 └└└d   └└└└└└    m8└└└d   └└└└└└▒8└└└d   └└└└└└
  245. ⌡8ÇÇÇd   └└└└└└99ÇÇÇd   └└└└└└    }9ÇÇÇd   └└└└└└┴9   ÇÇÇd   └└└└└└:   ÇÇÇd   └└└└└└    I:   ÇÇÇd   └└└└└└ì: └└└d   └└└└└└╤:Ç└└└d   └└└└└└;└└└d   └└└└└└Y;   d   └└└└└└@¥;   d   └└└└└└    @ß;└└└d   └└└└└└%<└└└d   └└└└└└    i<└└└└└└└└└¡<└└└└└└└└└    ±<└└└└└└5=└└└└└└    y=└└└U╜=└└└U    >└└└TE>└└└T    ë>└└└Y═>└└└X    ?└└└XU?└└└ÖÖ?└└└ÿ    ▌?└└└ÿ!@└└└⌐e@└└└¿    ⌐@└└└¿φ@└└└¬1A└└└d   └└└└└└    uA└└└¿    ╣A└└└d   └└└└└└    ²A└└└d   └└└└└└ AB└└└d   └└└└└└àB└└└ó╔B└└└á    C└└└áQC└└└ó    òC└└└ó┘C└└└d   └└└└└└
  246. D   d   └└└└└└@aD   d   └└└└└└    @ÑD   d   └└└└└└@ΘD└└└d   └└└└└└    -E   d   └└└└└└    @qE   d   └└└└└└    ╡E   d   └└└└└└    @∙E   d   └└└└└└@=F└└└d   └└└└└└    üF   d   └└└└└└    ┼F   d   └└└└└└    @    G   d   └└└└└└@MG└└└d   └└└└└└
  247. æG   d   └└└└└└
  248. @╒G   d   └└└└└└
  249. H   d   └└└└└└
  250. @]H   d   └└└└└└
  251. @íH   d   └└└└└└
  252. @σH└└└ó    )I   ÇÇÇd   └└└└└└mI   ÇÇÇd   └└└└└└    ▒I└└└d   └└└└└└⌡I└└└d   └└└└└└    9JÇÇÇd   └└└└└└}J└└└ó┴J└└└ó    K└└└óIK└└└d   └└└└└└ìK └└└d   └└└└└└    ╤KÇÇÇd   └└└└└└    L└└└d   └└└└└└
  253. YL└└└d   └└└└└└
  254. ¥L   ÇÇÇd   └└└└└└    ßL└└└d   └└└└└└%M└└└d   └└└└└└    iM└└└ó¡M└└└ó    ±M└└└ó5N└└└d   └└└└└└yN └└└d   └└└└└└    ╜NÇÇÇd   └└└└└└    O└└└d   └└└└└└
  255. EO└└└d   └└└└└└
  256. ëO   ÇÇÇd   └└└└└└═O └└└d   └└└└└└P└└└d   └└└└└└
  257. UP   d   └└└└└└
  258. @ÖP   d   └└└└└└▌P   d   └└└└└└
  259. !Q   d   └└└└└└    @eQ   d   └└└└└└@⌐Q   d   └└└└└└@φQ   d   └└└└└└@1RÇ└└└d   └└└└└└uR└└└d   └└└└└└╣R   d   └└└└└└    @²R└└└d   └└└└└└    AS└└└d   └└└└└└àS   d   └└└└└└    @╔S   d   └└└└└└@T   d   └└└└└└QT   d   └└└└└└
  260. @òT   d   └└└└└└@┘T╠╠╠d   └└└└└└U╠╠╠d   └└└└└└    aU╠╠╠d   └└└└└└ÑU╠╠╠óΘU╠╠╠ó    -V╠╠╠óqV╠╠╠d   └└└└└└╡V ╠╠╠d   └└└└└└    ∙V╠╠╠d   └└└└└└
  261. =W╠╠╠d   └└└└└└
  262. üW ╠╠╠d   └└└└└└┼W╠╠╠d   └└└└└└
  263.     XÇ╠╠╠d   └└└└└└MX╠╠╠d   └└└└└└bX HelvXTms Rmn Bold₧XHelvetica Bold╜X Helvetica Bold╫X
  264. Helvetica÷XHelvetica BoldYHelvetica Bold9YTms Rmn Bold Italic^YTimes New Roman BoldsYHelv    b[dz╝    Graph  1
  265. Script  1Ç @ ÇÇÇÇÇÇÇÇÇÇÇÇ╠╠╠            ≡wwwwwwwwwwpêêêêêêêêêêpêêêéêéêêêêpêêêéêéêêêêpêêê"""(êêêpêêé""""êêêpêê"éêéé(êêpêê(éêéê(êêpêêêéêéê(êêpêêêéêéé(êêpêêê""""êêêpêêé"""(êêêpêê"éêéêêêêpêê(éêéêêêêpêê(éêéê(êêpêê"éêéé(êêpêêé""""êêêpêêê"""(êêêpêêêéêéêêêêpêêêéêéêêêêpêêêêêêêêêêp          ≡≡
  266. ╡[.,$.,Ñ.,ú,.·[ÇE        $$Checking and Savings Account Example\Å        :\~Ä        Z\~Ä        z\~Ä        Ü\~Ä        ║\~║        ┌\~║        ·\~║        ]    ║        :]
  267. ║        Z] ║        z] ║        Ü]║        ║]║        ┌]H        ·]║        ^~╗        :^~║        Z^~║        z^~║        Ü^~║        ║^║        ┌^║        ·^║        _    ║        :_
  268. ║        Z_ ║        z_ ║        Ü_║        ║_║        ┌_H        N`Ç║        SSThis workbook demonstrates how you can use MScript to create a Checking and Savingsn`~╗        Ä`~║        «`~║        ╬`~║        ε`~║        a║        .a║        Na║        na    ║        Äa
  269. ║        «a ║        ╬a ║        εa║        b║        .bH        ªbÇ║        WWaccount in Mesa 2.  The Cover Page allows you to enter in a new entry and see a summary╞b~╗        µb~║        c~║        &c~║        Fc~║        fc║        åc║        ªc║        ╞c    ║        µc
  270. ║        d ║        &d ║        Fd║        fd║        ådH        eÇ║        aaof the balances of both accounts.  To enter a new entry into the account, fill in the information(e~╗        He~║        he~║        êe~║        ¿e~║        ╚e║        Φe║        f║        (f    ║        Hf
  271. ║        hf ║        êf ║        ¿f║        ╚f║        ΦfH        fgÇ║        ]]in the fields below and double click the abacus icon to enter the new entry.  The script willåg~╗        ªg~║        ╞g~║        µg~║        h~║        &h║        Fh║        fh║        åh    ║        ªh
  272. ║        ╞h ║        µh ║        i║        &i║        FiH        ╞iÇ║        __check the transaction type field to see if it matches one of the types it knows of.  The scriptµi~╗        j~║        &j~║        Fj~║        fj~║        åj║        ªj║        ╞j║        µj    ║        k
  273. ║        &k ║        Fk ║        fk║        åk║        ªkH        ≤kÇ║        ,,understands the following transaction types:l~║        3l~║        Sl~║        sl~║        ôl~║        │l║        ╙l║        ≤l║        m    ║        3m
  274. ║        Sm ║        sm ║        ôm║        │m║        ╙mH        ≤m~║        n~║        3n~║        Sn~║        sn~║        ôn~║        │n║        ╙n║        ≤n║        o    ║        3o
  275. ║        So ║        so ║        ôo║        │o║        ╙oH        p    ÇT        Transaction Type,p    ÇT        Used toLp    ~Æ        lp    ~Æ        îp    ~Æ        ¼p    ~Æ        ╠p    ║        ∞p    D}║         q    ║        ,q        ║        Lq    
  276. ║        lq     ║        îq     ║        ¼q    ║        ╠q    ║        ∞q    H        r
  277. Ç║        CDepositWr
  278. Ç║        !!Deposit into the Checking accountwr
  279. ~║        ùr
  280. ~║        ╖r
  281. ~║        ╫r
  282. ─}║        ≈r
  283. ║        s
  284. ║        7s
  285. ║        Ws
  286.     ║        ws
  288. ║        ùs
  289. ║        ╖s
  290. ║        ╫s
  291. ║        ≈s
  292. ║        t
  293. H        ;t Ç║        ATMät Ç║        ((ATM withdrawal from the Checking accountñt ~║        ─t ~║        Σt ~║        u ~║        $u ║        Du ║        du ║        äu     ║        ñu
  294. ║        ─u ║        Σu ║        v ║        $v ║        Dv H        mv Ç║        Transfer┐v Ç║        11Transfer from the Checking to the Savings Account▀v ~║         v ~║        w ~║        ?w ~║        _w Ç║        w ║        ƒw Ç║        ┐w     ║        ▀w
  295. ║         w ║        x ║        ?x ║        _x ║        x H        ¿xÇ║        A Number▐xÇ║        The number of a Check■x~║        y~║        >y~║        ^y~║        ~y║        ₧y║        ╛y║        ▐y    ║        ■y
  296. ║        z ║        >z ║        ^z║        ~z║        ₧zH        ╟zÇ║        SDeposit{Ç║        Deposit to the Savings Account&{~║        F{~║        f{~║        å{~║        ª{║        ╞{║        µ{║        |    ║        &|
  297. ║        F| ║        f| ║        å|║        ª|║        ╞|H        ∩|Ç║        Interest/}Ç║        Interest on the Savings AccountO}~║        o}~║        Å}~║        »}~║        ╧}║        ∩}║        ~║        /~    ║        O~
  298. ║        o~ ║        Å~ ║        »~║        ╧~║        ∩~H        ~║        /~║        O~║        o~║        Å~║        »~║        ╧║        ∩║        Ç║        /Ç    ║        OÇ
  299. ║        oÇ ║        ÅÇ ║        »Ç║        ╧Ç║        ∩ÇH        ,üÇ╝        Now try it out for yourself!Lü~╗        lü~║        îü~║        ¼ü~║        ╠ü~║        ∞ü║         é║        ,é║        Lé    ║        lé
  300. ║        îé ║        ¼é ║        ╠é║        ∞é║         âH        ,â~║        Lâ~╗        lâ~║        îâ~║        ¼â~║        ╠â~║        ∞â║         ä║        ,ä║        Lä    ║        lä
  301. ║        îä ║        ¼ä ║        ╠ä║        ∞ä║         àH        =àÇT        Transaction TypebàÇU        Date¥àÇT        Description of Transaction├àÇT        Valueπà~Æ        å~Æ        #å║        Cå║        cå║        âå    ║        úå
  302. ║        ├å ║        πå ║        ç║        #ç║        CçH        cç~╜        âç~╛        úç~╜        ├ç~┐        πç~└        ê~║        #ê║        Cê║        cê║        âê    ║        úê
  303. ║        ├ê ║        πê ║        ë║        #ë║        CëH        cë~║        âë~║        úë~║        ├ë~║        πë~║        è~║        #è║        Cè║        cè║        âè    ║        úè
  304. ║        ├è ║        πè ║        ï║        #ï║        CïH        cï~║        âï~║        ΦïÇ┴        DDClick this button once you have entered the Transaction information:î~║        (î~║        Hî~║        hî║        êî║        ¿î║        ╚î    ║        Φî
  305. ║        ì ║        (ì ║        Hì║        hì║        êìH        ¿ì~║        ╚ì~║        Φì~║        Ä~║        (Ä~║        HÄ~║        hÄ║        êÄ║        ¿Ä║        ╚Ä    ║        ΦÄ
  306. ║        Å ║        (Å ║        HÅ║        hÅ║        êÅH        ╤ÅÇV        ((Summary Information for the two accounts±Å~ÿ        É~Æ        1É~Æ        QÉ~Æ        qÉ~Æ        æÉ║        ▒É║        ╤É║        ±É    ║        æ
  307. ║        1æ ║        Qæ ║        qæ║        ææ║        ▒æH        ╤æ~║        ±æ~╗        Æ~║        1Æ~║        QÆ~║        qÆ~║        æÆ║        ▒Æ║        ╤Æ║        ±Æ    ║        ô
  308. ║        1ô ║        Qô ║        qô║        æô║        ▒ôH        ╤ô~║         öÇ┬        Checking Account Balance:SöÇ├$$1CheckingBalance    hë@sö~║        ôö~║        │ö~║        ╙ö║        ≤ö║        ò║        3ò    ║        Sò
  309. ║        sò ║        ôò ║        │ò║        ╙ò║        ≤òH        û~║        LûÇ┬        Savings Account Balance:öûÇ├$$1SavingsBalanceA    ╚Æ@┤û~║        ╘û~║        ⌠û~║        ù║        4ù║        Tù║        tù    ║        öù
  310. ║        ┤ù ║        ╘ù ║        ⌠ù║        ÿ║        4ÿH        Tÿ║        tÿ~║        öÿ~║        ┤ÿ~║        ╘ÿ~║        ⌠ÿ~║        Ö║        4Ö║        TÖ║        tÖ    ║        öÖ
  311. ║        ┤Ö ║        ╘Ö ║        ⌠Ö║        Ü║        4ÜH        TÜ~║        tÜ~║        öÜ~║        ┤Ü~║        ╘Ü~║        ⌠Ü~║        ¢║        4¢║        T¢║        t¢    ║        ö¢
  312. ║        ┤¢ ║        ╘¢ ║        ⌠¢║        £║        4£H        T£~║        t£~║        ö£~║        ┤£~║        ╘£~║        ⌠£~║        ¥║        4¥║        T¥║        t¥    ║        ö¥
  313. ║        ┤¥ ║        ╘¥ ║        ⌠¥║        ₧║        4₧H        T₧~║        t₧~╗        ö₧~║        ┤₧~║        ╘₧~║        ⌠₧~║        ƒ║        4ƒ║        Tƒ║        tƒ    ║        öƒ
  314. ║        ┤ƒ ║        ╘ƒ ║        ⌠ƒ║        á║        4áH        iáÇ─        Checking Account Logëá┼        ⌐á~║        ╔á~║        Θá~║            í~║        )í~║        Ií        ií        ëí            ⌐í
  315.         ╔í         Θí             ó        )ó        Ió        ió        ëóÇ        ⌐ó        ╔ó~        Θó            ú~⌐        )ú        Iú~        iú        ëú~        ⌐ú        ╔ú~        Θú            ñ            )ñ
  316.         Iñ         iñ         ëñ        ⌐ñ        ╔ñ        Θñ            Ñ        )Ñ        IÑ        ╦ÑǬ        aaThis page is a simple Checking Account Log.  Take a look at cell F9.  This cell computes the fee δÑ~½         ª~¬        +ª~¬        Kª~¬        kª~¬        ïª~¬        ½ª        ╦ª~        δª             º
  317. ~        +º         Kº ~        kº        ïº~        ½º        ╦º~        δº         ¿~        +¿        «¿Ç        bbcharged by the bank based on various transaction types. Though you can't see it, the Total Balance╬¿~½        ε¿~¬        ⌐~¬        .⌐~¬        N⌐~¬        n⌐~¬        Ä⌐        «⌐        ╬⌐            ε⌐
  318.         ¬         .¬         N¬        n¬        Ĭ        «¬        ╬¬        ε¬        ½~        æ½Ç        bbis a labeled cell.  The Checking Account Balance in the Cover Page refers to the name of this cell▒½~½        ╤½~¬        ±½~¬        ¼~¬        1¼~¬        Q¼~¬        q¼~        æ¼        ▒¼    ~        ╤¼
  319.         ±¼         ¡         1¡        Q¡        q¡        æ¡        ▒¡        ╤¡        ±¡        e«Ç        SSrather than the cell itself, thus allowing you to use a useful name to refer to it.à«~½        Ñ«~¬        ┼«~¬        σ«~¬        »~¬        %»~¬        E»        e»        à»            Ñ»
  320. ~        ┼»         σ» Ç        ░        %░Ç        E░        e░~        à░        Ñ░~        ┼░        σ░~        ▒~⌐        %▒        E▒        e▒        à▒        Ñ▒        ┼▒        σ▒        ▓            %▓
  321.         E▓         e▓         à▓        Ñ▓        ┼▓        σ▓        │        %│        E│        v│Ç        Transaction Type¢│Çà        Date╓│Ç        Description of Transaction■│Ç        Deposit)┤Ç        
  323. WithdrawalM┤Ç        Feeu┤Ç        Balanceò┤~        ╡┤        ╒┤    ~        ⌡┤
  324.         ╡ ~        5╡         U╡        u╡        ò╡        ╡╡        ╒╡        ⌡╡        ╢        >╢Ç        CDepositb╢⌐        πα@æ╢Ç        Opened account╡╢Ç¡         î@╒╢~¡        æ╖Ç¡ÿÿá√ Q ,á√ ATM,Φ? ≡?     ╕Ç¡LLú² ñ■ Ñ       î@!╕        A╕        a╕            ü╕
  325.         í╕         ┴╕ ~        ß╕        ╣~        !╣        A╣~        a╣        ü╣~        í╣        ┼╣    ~«        Y@Θ╣    ~⌐        áπα@║    Ç        Rent.║    ~¡        R║    Ç¡        αu@╗    Ç¡ÿÿ┤√ Q ,┤√ ATM,Φ? ≡?     ≡?û╗    Ç¡ddª   ╖² ╕■ ╣      (ü@╢╗            ╓╗            ÷╗                ╝    
  326.         6╝             V╝             v╝            û╝            ╢╝            ╓╝            ÷╝            ╜            6╜            Z╜
  327. Ç        ATM~╜
  328. Ç⌐        απα@₧╜
  329.         ╛╜
  330. ~¡        Γ╜
  331. ~¡        i@₧╛
  332. Ç¡ÿÿ╚√ Q ,╚√ ATM,Φ? ≡?     Φ?&┐
  333. Ç¡dd║   ╦² ╠■ ═      ─u@F┐
  334. ~        f┐
  335.         å┐
  336.     ~        ª┐
  337. 
  338.         ╞┐
  339.  ~        µ┐
  340.          └
  341. ~        &└
  342.         F└
  343.         f└
  344.         å└
  345.         ª└
  346.         ╞└
  347.         Ω└ ~«        @Y@┴ ~⌐        `Σα@9┴ Ç        
  349. Phone BillY┴ ~¡        }┴ ~¡        I@9┬ Ç¡ÿÿ▄√ Q ,▄√ ATM,Φ? ≡?     ≡?┴┬ Ç¡dd╬   ▀² α■ ß      ör@ß┬         ├         !├             A├ 
  350.         a├          ü├          í├         ┴├ ~        ß├         ─ ~        !─         A─ ~        a─         à─ ~«        ÇY@⌐─ ~⌐        `Σα@╓─ Ç         Heating Bill÷─ ~¡        ┼ ~¡        D@╓┼ Ç¡ÿÿ≡√ Q ,≡√ ATM,Φ? ≡?     ≡?^╞ Ç¡ddΓ   ≤² ⌠■ ⌡      p@~╞         ₧╞         ╛╞             ▐╞ 
  351.         ■╞          ╟          >╟         ^╟         ~╟         ₧╟         ╛╟         ▐╟         ■╟         "╚~«        └Y@F╚~⌐        `Σα@w╚Ç        Electricity Billù╚~¡        ╗╚~¡        4@w╔Ç¡ÿÿ√ Q ,√ ATM,Φ? ≡?     ≡? ╔Ç¡dd÷   ² ■           hm@╩~        ?╩~        _╩    ~        ╩
  352. ~        ƒ╩ ~        ┐╩ Ç        ▀╩~         ╩~        ╦~        ?╦~        _╦~        ╦~        ƒ╦Ç        ├╦Ç        ATMτ╦~⌐        ÇΣα@╠~        '╠~¡        K╠~¡        └b@═Ç¡ÿÿ√ Q ,√ ATM,Φ? ≡?     Φ?Å═Ç¡dd
  353.    ² ■        U@»═~        ╧═~        ∩═    ~        ╬
  354. ~        /╬ ~        O╬ ~        o╬Ç        Å╬~        »╬~        ╧╬~        ∩╬~        ╧~        /╧~        X╧Ç        CDeposit|╧Ç⌐        └Σα@┤╧Ç        Paycheck-Direct Deposit╪╧~¡        └Æ@°╧~¡        ┤╨Ç¡ÿÿ,√ Q ,,√ ATM,Φ? ≡?     <╤Ç¡dd   /² 0■ 1      ö@\╤Ç        |╤Ç        £╤            ╝╤
  355. Ç        ▄╤ Ç        ⁿ╤ ~        ╥Ç        <╥Ç        \╥~        |╥~        £╥Ç        ╝╥~        ▄╥Ç        ╙Ç        ATM$╙Ç⌐        Çσα@D╙Ç        d╙¡        ê╙Ç¡        @e@D╘Ç¡ÿÿ@√ Q ,@√ ATM,Φ? ≡?     Φ?╠╘Ç¡dd2   C² D■ E      gæ@∞╘Ç         ╒~        ,╒    ~        L╒
  356. Ç        l╒ ~        î╒ ~        ¼╒Ç        ╠╒Ç        ∞╒~         ╓~        ,╓Ç        L╓~        l╓~        ò╓Ç        Transfer╣╓Ç⌐        Çσα@⌡╓Ç        Transfer to Savings Account╫~¡        9╫~¡        i@⌡╫Ç¡ÿÿT√ Q ,T√ ATM,Φ? ≡?     }╪Ç¡ddF   W² X■ Y      Äî@¥╪Ç        ╜╪Ç        ▌╪    Ç        ²╪
  357. ~        ┘ ~        =┘ ~        ]┘Ç        }┘Ç        ¥┘Ç        ╜┘Ç        ▌┘Ç        ²┘~        ┌~        A┌~        ATMe┌~»        τα@à┌~        Ñ┌Ç        ╔┌pv¡        Y@à█Ç¡ÿÿh√ Q ,h√ ATM,Φ? ≡?     Φ?▄Ç¡ddZ   k² l■ m      hë@-▄Ç        M▄Ç        m▄    Ç        ì▄
  358. Ç        ¡▄ ~        ═▄ ~        φ▄Ç        ▌Ç        -▌~        M▌~        m▌~        ì▌v        ¡▌Ç        ═▌Ç        φ▌Ç        ▐Ç        -▐Ç        M▐■        m▐■        ì▐■        ¡▐■        ═▐■        φ▐    ~        ▀
  359. ~        -▀ ~        M▀ ~        m▀~        ì▀Ç        ¡▀        ═▀~        φ▀~        α~        -α~        SαÇ        TotalïαÇ⌐φ    ╛ä÷╥╒ß@½α~        ╦αÇ        δα~         ß~        KßÇ¡n■      hë@kß~        ïß~        ½ß    Ç        ╦ß
  360. ~        δß ~         Γ Ç        +Γ~        KΓ~        kΓ~        ïΓ~        ½ΓÇ        ╦ΓÇ        δΓÇ         πÇ        +πÇ        KπÇ        kπÇ        ïπÇ        ½π        ╦πÇ        δπÇ         Σ~        +Σ    Ç        KΣ
  361. Ç        kΣ ~        ïΣ ~        ½ΣÇ        ╦Σ~        δΣÇ         σÇ        +σÇ        Kσ~        kσ~        ïσÇ        ½σ■⌐        ╦σÇ        δσÇ         µÇ        +µÇ        KµÇ        kµÇ        ïµ~        ½µ    ~        ╦µ
  362. ~        δµ ~         τ ~        +τ~        Kτ~        kτ~        ïτ~        ½τ~        ╦τ~        δτ~         Φ~        +Φ■⌐        KΦ~        kΦ~        ïΦ~        ½Φ~        ╦Φ~        δΦ~         Θ~        +Θ    ~        KΘ
  363. ~        kΘ ~        ïΘ ~        ½Θ~        ╦Θ~        δΘ~         Ω~        +Ω~        KΩ~        kΩ~        ïΩ        ½Ω■⌐        ╦Ω        δΩ         δ        +δ        Kδ        kδ        ïδ        ½δ            ╦δ
  364.         δδ          ∞         +∞        K∞        k∞        ï∞        ½∞        ╦∞        δ∞         φ        +φ■⌐        Kφ        kφ        ïφ        ½φ        ╦φ        δφ         ε        +ε            Kε
  365.         kε         ïε         ½ε        ╦ε        δε         ∩        +∩        K∩        k∩        ï∩        ½∩■⌐        ╦∩        δ∩         ≡        +≡        K≡        k≡        ï≡        ½≡            ╦≡
  366.         δ≡          ±         +±        K±        k±        ï±        ½±        ╦±        δ±         ≥        +≥~⌐        K≥        k≥        ï≥        ½≥        ╦≥        δ≥         ≤        +≤            K≤
  367.         k≤         ï≤         ½≤        ╦≤        δ≤         ⌠        +⌠        K⌠        k⌠        ï⌠        ½⌠~⌐        ╦⌠        δ⌠         ⌡        +⌡        K⌡        k⌡        ï⌡        ½⌡            ╦⌡
  368.         δ⌡          ÷         +÷        K÷        k÷        ï÷        ½÷        ╦÷        δ÷         ≈        +≈~⌐        K≈        k≈        ï≈        ½≈        ╦≈        δ≈         °        +°            K°
  369.         k°         ï°         ½°        ╦°        δ°         ∙        +∙        K∙        k∙        ï∙        ½∙~⌐        ╦∙        δ∙         ·        +·        K·        k·        ï·        ½·            ╦·
  370.         δ·          √         +√        K√        k√        ï√        ½√        ╦√        δ√         ⁿ        +ⁿ~⌐        Kⁿ        kⁿ        ïⁿ        ½ⁿ        ╦ⁿ        δⁿ         ²        +²            K²
  371.         k²         ï²         ½²        ╦²        δ²         ■        +■        K■        k■        ƒ■Ç╞        Savings Account Log┐■╗        ▀■~║         ■~║         ~║        ? ~║        _ ╟                 ƒ         ┐             ▀ 
  372.                             ?        _                ƒ        ┐        ▀                         ?~▓        _                ƒ        ┐~        ▀~¡                         ?            _
  373.                  ƒ         ┐        ▀                         ?        _                Ǭ        ggThis page is a simple Savings Account Log.  Take a look at cell F9.  This cell computes the fee charged'~▓        G        g        çÇ        º        ╟~¡        τ~        ~        '    ~        G
  374.         g ~        ç ~        ºÇ        ╟~        τ~        Ç        '~        G~        gÇ        ≡Ç        hhby the bank based on various transaction types.  Though you can't see it, the Total Balance is a labeled~▓        0Ç        P~        p~        É~        ░~¡        ╨Ç        ≡Ç            Ç        0
  375. Ç        P Ç        p Ç        ÉÇ        ░Ç        ╨        ≡Ç            Ç        0    ~        P    Ç        ┘    Ç        hhcell.  The Checking Account Balance in the Cover Page refers to the name of this cell rather than to the∙    ~▓        
  376. ~        9
  377. Ç        Y
  378. ~        y
  379. Ç        Ö
  380. ~¡        ╣
  381. Ç        ┘
  382. ~        ∙
  383.     ~         
  384. Ç        9  ~        Y  Ç        y Ç        Ö Ç        ╣ Ç        ┘ Ç        ∙ Ç         ~        9 ~        ╡ Ç        [[cell itself, allowing you to use a useful name rather than a cell reference to refer to it.╒ ~▓        ⌡ ~        ~        5~        U~        u~¡        ò~        ╡~        ╒    ~        ⌡
  385. ~         ~        5 ~        U~        u~        ò~        ╡~        ╒~        ⌡~        ~        5~        U~▓        u~        ò~        ╡~        ╒~        ⌡~¡        ~        5~        U    ~        u
  386.         ò         ╡         ╒        ⌡                5        U        u        ò        ╞Ç        Transaction TypeδÇ:        Date&Ç        Description of TransactionNÇ        DeposityÇ        
  388. Withdrawal¥Ç        Fee┼Ç<        Balanceσ                %            E
  389.         e         à         Ñ        ┼        σ                %        E        e        ÄÇ        SDeposit▓⌐        πα@ßÇ        Opened accountÇ¡        @Å@%~¡        ßÇ¡ÿÿ √ Q , √ ATM,Φ? ≡?     QÇ¡LL#² $■ %      @Å@q        æ        ▒            ╤
  390.         ±                  1        Q        q        æ        ▒        ╤        ±            ~«        Interest>    ~⌐        └Σα@g    Ç        Interestï    ~¡        @½    Ç¡        g    Ç¡ÿÿ4√ Q ,4√ ATM,Φ? ≡?     ∩    Ç¡dd&   7² 8■ 9      PÅ@            /            O                o    
  391.         Å             »             ╧            ∩                        /            O            o            Å            ╕
  392. ~«        Transfer▄
  393. ~⌐        Çσα@
  394. Ç        Transfer to Savings Account<
  395. ~¡        i@\
  396. Ç¡        °
  397. Ç¡xxH√  Interest,:   {«Gßzö?     Ç
  398. Ç¡dd:   K² L■ M      ╚Æ@á
  399.         └
  400.         α
  401.             
  402. 
  403.          
  404.          @
  405.          `
  406.         Ç
  407.         á
  408.         └
  409.         α
  410.         
  411.          
  412.         @         `         Ç         á         └         α                              @          `              Ç  
  413.         á           └           α          !          !         @!         `!         Ç!         á!         ╞! Ç        Total■! Ç⌐φ    ╛ä÷╥╒ß@"         >"         ^"         ~"         ╛" Ç¡N■      ╚Æ@▐"         ■"         #             ># 
  414.         ^#          ~#          ₧#         ╛#         ▐#         ■#         $         >$         ^$         ~$        ₧$        ╛$        ▐$        ■$        %        >%        ^%        ~%        ₧%            ╛%
  415.         ▐%         ■%         &        >&        ^&        ~&        ₧&        ╛&        ▐&        ■&        '        >'        ^'        ~'        ₧'        ╛'        ▐'        ■'        (            >(
  416.         ^(         ~(         ₧(        ╛(        ▐(        ■(        )        >)        ^)        ~)        ₧)~▓        ╛)        ▐)        ■)        *        >*        ^*        ~*        ₧*            ╛*
  417.         ▐*         ■*         +        >+        ^+        ~+        ₧+        ╛+        ▐+        ■+        ,~▓        >,        ^,        ~,        ₧,        ╛,        ▐,        ■,        -            >-
  418.         ^-         ~-         ₧-        ╛-        ▐-        ■-        .        >.        ^.        ~.        ₧.~▓        ╛.        ▐.        ■.        /        >/        ^/        ~/        ₧/            ╛/
  419.         ▐/         ■/         0        >0        ^0        ~0        ₧0        ╛0        ▐0        ■0        1~▓        >1        ^1        ~1        ₧1        ╛1        ▐1        ■1        2            >2
  420.         ^2         ~2         ₧2        ╛2        ▐2        ■2        3        >3        ^3        ~3        ₧3~▓        ╛3        ▐3~¡        ■3~¡        4~¡        >4        ^4        ~4        ₧4            ╛4
  421.         ▐4         ■4         5        >5        ^5        ~5        ₧5        ╛5        ▐5        ■5        6~▓        >6        ^6        ~6        ₧6        ╛6~¡        ▐6        ■6        7            >7
  422.         ^7         ~7         ₧7        ╛7        ▐7        ■7        8        >8        ^8        ~8        ₧8~▓        ╛8        ▐8        ■8        9        >9~¡        ^9        ~9        ₧9            ╛9
  423.         ▐9         ■9         :        >:        ^:        ~:        ₧:        ╛:        ▐:        ■:        ;~▓        >;        ^;        ~;        ₧;        ╛;~¡        ▐;        ■;        <            ><
  424.         ^<         ~<         ₧<        ╛<        ▐<        ■<        =        >=        ^=        ~=        ₧=~▓        ╛=        ▐=        ■=        >        >>~¡        ^>        ~>        ₧>            ╛>
  425.         ▐>         ■>         ?        >?        ^?        ~?        ₧?        ╛?        ▐?        ■?        @~▓        >@        ^@        ~@        ₧@        ╛@~¡        ▐@        ■@        A            >A
  426.         ^A         ~A         ₧A        ╛A        ▐A        ■A        B        >B        ^B        ~B        ₧B~▓        ╛B        ▐B        ■B        C        >C~¡        ^C        ~C        ₧C            ╛C
  427.         ▐C         ■C         D        >D        ^D        ~D        ₧D        ╛D        ▐D        ■D        E~▓        >E        ^E        ~E        ₧E        ╛E~¡        ▐E        ■E        F            >F
  428.         ^F         ~F         ₧F        ╛F        ▐F        ■F        G        >G        ^G        ~G        ₧G~▓        ╛G        ▐G        ■G        H        >H~¡        ^H        ~H        ₧H            ╛H
  429.         ▐H         ■H         I        >I        ^I        ~I        ₧I        ╛I        ▐I        ■I        J~▓        >J        ^J        ~J        ₧J        ╛J~¡        ▐J        ■J        K            >K
  430.         ^K         ~K         ₧K        ╛K        ▐K        ■K        L        >L        ^L        ~L        ₧L~▓        ╛L        ▐L        ■L        M        >M~¡        ^M        ~M        ₧M            ╛M
  431.         ▐M         ■M         N        >N        ^N        ~N        ₧N        ╛N        ▐N        ■N        O~▓        >O        ^O        ~O        ₧O        ╛O~¡        ▐O        ■O        P            >P
  432.         ^P         ~P         ₧P        ╛P        ▐P        ■P        Q        >Q        ^Q        ~Q        ₧Q~▓        ╛Q        ▐Q        ■Q        R        >R~¡        ^R        ~R        ₧R            ╛R
  433.         ▐R         ■R         S        >S        ^S        ~S        ₧S        ╛S        ▐S        µS